Видео с ютуба Excel Magic Trick
Excel Magic Tricks # 1: Formulas & Cell References
Excel Magic Trick 1028: Create Hyperlinks to Duplicate Text Titles In Column A On Different Sheet
Excel Magic Trick 186 Dynamic Formula Extract Data 2 criteria
Excel Magic Trick 1009: Lookup 3 Different Arrays From 3 Different Tables: VLOOKUP, CHOOSE, INDEX
Excel Magic Trick 1031: Four Way Lookup Formula To Deliver Multiple Items From 1 of 2 Lookup Tables
Excel Magic Trick 1377: Lookup Formula To List All Incomplete Assignments: INDEX, TEXTJOIN & More
Excel Magic Trick 608: Array Formula To Return Multiple Items - List Students With Free Periods